Model Table COMPATIBLE UNIT
This model dimension represents the Compatible Units and is based on the IFS
Cloud dimension DIM_CMPUNT_COMPATIBLE_UNIT. All models that refers to
this dimension will have the attributes and hierarchies as described below.
Attributes
| Attribute |
Description (where applicable) |
| CU Id | Compatible Unit Id |
| Class | Class |
| Company | Company Code |
| Compatible Unit | Name + Description |
| Compatible Unit Sq | Sequence Number, Internal Database
Key |
| Compatible Unit Type | Compatible Unit Type |
| Configuration Id | Configuration Id |
| Description | Compatible Unit Description |
| Estimate Revision | Indicates if this is the revision
used for estimations True =1, False =0 |
| Parent Id | Parent Unit Id |
| Parent Rev | Parent Unit Revision No |
| Parent Seq | Parent Unit Sequence No |
| Plant | Plant Description |
| Project Id | Project ID |
| Revision No | Revision Number |
| Site | Site Code |
| Status | Compatible Unit Status |
| Template Id | Template unit ID from which Compatible
Unit derived |
| Template Revision No | Revision Number of Template unit,
from which Compatible Unit derived |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| COMPATIBLE UNIT | DIM_CMPUNT_COMPATIBLE_UNIT_TM | DIM_CMPUNT_COMPATIBLE_UNIT_BI | DIM_CMPUNT_COMPATIBLE_UNIT | On Line |